FaYear 
Logical Entity Name  FaYear 
Default Table Name  FaYear 
Physical Only  NO 
Definition 
 
Note 
 

FaYear Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Code    char(9)  NO 
 
Descrip    varchar(30)  NO 
 
StartDate    datetime  NO 
 
EndDate    datetime  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
UserID    int  NO 
 
Active    bit  NO 
 
ModFlag    char(1)  NO 
 
ts    timestamp  NO 
 
FaYearID(PK)    char(2)  NO 
 
DisplayInUI    int  NO 
 

FaYear Primary and Unique Keys 
Key Name  Key Type  Keys 
FaYear_FaYearID_U_C_IDX  PrimaryKey  FaYearID 

FaYear Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdGainfulEmploymentAwardYearSchema  Non-Identifying  One To Zero or More  FK_AdGainfulEmploymentAwardYearSchemaFaYearId_FaYearFaYearId        NO  YES 
AdGainfulEmploymentReportingDetails  Non-Identifying  One To Zero or More  FK_AdGainfulEmploymentReportingDetailsFaYearID_FaYearFaYearID        NO  YES 
FaAaiTaxRate  Non-Identifying  One To Zero or More  FK_FaAaiTaxRateFaYearId_FaYearFaYearId        NO  YES 
FaAwardYearMaxAmt  Non-Identifying  One To Zero or More  FK_FaAwardYearMaxAmt_FaYearID_FaYear_FaYearID        NO  YES 
FaAwardYearPellGrid  Non-Identifying  One To Zero or More  FK_FaAwardYearPellGridFaYearId_FaYearFaYearId        NO  YES 
FaCfpGrantOptionsConfig_Regulatory  Non-Identifying  One To Zero or More  FK_FaCfpGrantOptionsConfig_RegulatoryFaYearId_FaYearFaYearId        NO  YES 
FaCfpInterestRateConfig_Regulatory  Non-Identifying  One To Zero or More  FK_FaCfpInterestRateConfig_RegulatoryFaYearId_FaYearFaYearId        NO  YES 
FaCfpWorkStudyConfig_Regulatory  Non-Identifying  One To Zero or More  FK_FaCfpWorkStudyConfig_RegulatoryFaYearId_FaYearFaYearId        NO  YES 
FaEducationSavingsAllowance  Non-Identifying  One To Zero or More  FK_FaEducationSavingsAllowanceFaYearId_FaYearFaYearId        NO  YES 
FaFAFSAAwardYearSchema  Non-Identifying  One To Zero or More  FK_FaFAFSAAwardYearSchemaFaYearId_FaYearFaYearId        NO  YES 
FaFisapIncomeBracket  Non-Identifying  One To Zero or More  FK_FaFisapIncomeBracketFaYearID_FaYearFaYearID        NO  YES 
FaIncomeProtectionAllowance  Non-Identifying  One To Zero or More  FK_FaIncomeProtectionAllowanceFaYearId_FaYearFaYearId        NO  YES 
FaISIRAssumption  Non-Identifying  One To Zero or More  FK_FaISIRAssumptionFaYearId_FaYearFaYearId        NO  YES 
FaISIRAwardYearSchema  Non-Identifying  One To Zero or More  FK_FaISIRAwardYearSchemaFaYearId_FaYearFaYearId        NO  YES 
FaISIRCorrection  Non-Identifying  One To Zero or More  FK_FaISIRCorrectionFaYearId_FaYearFaYearId        NO  YES 
FaISIRImportTrackLog  Non-Identifying  One To Zero or More  FK_FaISIRImportTrackLogFaYearId_FaYearFaYearId        NO  YES 
FaISIRRejection  Non-Identifying  One To Zero or More  FK_FaISIRRejectionFaYearId_FaYearFaYearId        NO  YES 
FaISIRSparseData  Non-Identifying  One To Zero or More  FK_FaISIRSparseData_FaYearId_FaYear_FaYearId        NO  YES 
FaISIRStudentMatch  Non-Identifying  One To Zero or More  FK_FaISIRStudentMatchFaYearId_FaYearFaYearId        NO  YES 
FaNetWorthAdjustment  Non-Identifying  One To Zero or More  FK_FaNetWorthAdjustmentFaYearId_FaYearFaYearId        NO  YES 
FaShoppingSheetCommentsConfig  Non-Identifying  One To Zero or More  FK_FaShoppingSheetCommentsConfigFaYearId_FaYearFaYearId        NO  YES 
FaShoppingSheetCostsConfig  Non-Identifying  One To Zero or More  FK_FaShoppingSheetCostsConfigFaYearId_FaYearFaYearId        NO  YES 
FaShoppingSheetLoanOptionsConfig  Non-Identifying  One To Zero or More  FK_FaShoppingSheetLoanOptionsConfigFaYearId_FaYearFaYearId        NO  YES 
FaSocialSecurityTaxRate  Non-Identifying  One To Zero or More  FK_FaSocialSecurityTaxRateFaYearId_FaYearFaYearId        NO  YES 
FaStateTaxAllowance  Non-Identifying  One To Zero or More  FK_FaStateTaxAllowanceFaYearId_FaYearFaYearId        NO  YES 
FaYearExternalMap  Non-Identifying  One To Zero or More  FK_FaYearExternalMapFaYearId_FaYearFaYearId        NO  YES 

FaYear Check Constraints 
Check Constraint Name  CheckConstraint